/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50711
 Source Host           : localhost
 Source Database       : igogogo

 Target Server Type    : MySQL
 Target Server Version : 50711
 File Encoding         : utf-8

 Date: 10/31/2017 21:14:37 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ig_admin`
-- ----------------------------
DROP TABLE IF EXISTS `ig_admin`;
CREATE TABLE `ig_admin` (
  `adminId` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员编号',
  `adminName` varchar(10) DEFAULT NULL COMMENT '管理员账号',
  `adminPwd` varchar(50) DEFAULT NULL COMMENT '管理员密码',
  `adminLastLoginTime` datetime DEFAULT NULL COMMENT '管理员最后登录时间',
  `addTime` datetime DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`adminId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `ig_admin`
-- ----------------------------
BEGIN;
INSERT INTO `ig_admin` VALUES ('2', 'chen', 'ec00273578a1bd42142996a7757c8eb9', '2017-10-27 18:14:45', '2017-10-27 18:14:45'), ('3', 'liang', 'e44ef0b0b4a680846c908c979b2062e0', '2017-10-27 18:45:54', '2017-10-27 18:45:54'), ('4', 'chen1', 'c3d260155b61386ae6b6386190875dc5', '2017-10-27 21:47:29', '2017-10-27 21:47:29'), ('5', 'chen2', 'a631d55bbb60ce2392a1de2204de8493', '2017-10-27 21:47:58', '2017-10-27 21:47:58'), ('6', 'chen3', '1675faa74b2d72d3da0fc83ffb5fa5b7', '2017-10-27 21:56:16', '2017-10-27 21:56:16');
COMMIT;

-- ----------------------------
--  Table structure for `ig_alievents`
-- ----------------------------
DROP TABLE IF EXISTS `ig_alievents`;
CREATE TABLE `ig_alievents` (
  `eventId` int(11) NOT NULL AUTO_INCREMENT COMMENT '活动编号',
  `eventPic` varchar(200) DEFAULT NULL COMMENT '活动图片',
  `eventTitle` varchar(50) DEFAULT NULL COMMENT '活动标题',
  `eventUrl` varchar(500) DEFAULT NULL COMMENT '活动链接地址',
  `eventOrder` int(11) DEFAULT NULL COMMENT '活动排序',
  `eventPlatform` varchar(20) DEFAULT NULL COMMENT '活动平台',
  `addTime` datetime DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`eventId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `ig_category`
-- ----------------------------
DROP TABLE IF EXISTS `ig_category`;
CREATE TABLE `ig_category` (
  `categoryId` int(11) NOT NULL AUTO_INCREMENT COMMENT '类别编号',
  `categoryName` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '类别名称',
  PRIMARY KEY (`categoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `ig_category`
-- ----------------------------
BEGIN;
INSERT INTO `ig_category` VALUES ('1', '女装'), ('2', '男装'), ('3', '母婴'), ('4', '美妆'), ('5', '鞋包配饰'), ('6', '美食'), ('7', '数码家电'), ('8', '内衣'), ('9', '运动户外'), ('10', '家居家装'), ('11', '测试1'), ('12', '测试2'), ('13', '测试3'), ('14', '测试4');
COMMIT;

-- ----------------------------
--  Table structure for `ig_itemcoupon`
-- ----------------------------
DROP TABLE IF EXISTS `ig_itemcoupon`;
CREATE TABLE `ig_itemcoupon` (
  `itemcouponId` int(11) NOT NULL AUTO_INCREMENT COMMENT '好卷编号',
  `numIid` bigint(20) DEFAULT NULL COMMENT '商品编号',
  `title` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '商品标题',
  `itemUrl` varchar(100) DEFAULT NULL COMMENT '商品详情页链接地址',
  `couponClickUrl` varchar(500) DEFAULT NULL COMMENT '商品优惠券推广链接',
  `couponInfo` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '优惠券面额',
  `pictUrl` varchar(255) DEFAULT NULL COMMENT '商品主图',
  `smallImages` varchar(500) DEFAULT NULL COMMENT '商品小图',
  `itemDescription` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '宝贝描述（推荐理由）',
  `sellerId` bigint(20) DEFAULT NULL COMMENT '卖家id',
  `couponStartTime` varchar(20) DEFAULT NULL COMMENT '优惠券开始时间',
  `couponEndTime` varchar(20) DEFAULT NULL COMMENT '优惠券结束时间',
  `shopTitle` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '店铺名称',
  `volume` bigint(20) DEFAULT NULL COMMENT '30天销量',
  `zkFinalPrice` double(6,2) DEFAULT NULL COMMENT '折扣价',
  `categoryId` int(11) DEFAULT NULL COMMENT '类别编号',
  `addTime` datetime DEFAULT NULL COMMENT '添加时间',
  `tpwd` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '淘口令',
  `shortUrl` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`itemcouponId`),
  KEY `categoryId` (`categoryId`),
  CONSTRAINT `ig_itemcoupon_ibfk_1` FOREIGN KEY (`categoryId`) REFERENCES `ig_category` (`categoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `ig_itemcoupon`
-- ----------------------------
BEGIN;
INSERT INTO `ig_itemcoupon` VALUES ('8', '560641410537', '2017秋冬新款韩版麻花条纹女圆领修身针织衫内搭内衬打底衫毛衣', 'http://detail.tmall.com/item.htm?id=560641410537', 'https://uland.taobao.com/coupon/edetail?e=jKqykJnaJGwGQASttHIRqR%2Fv0UDjYzqdjtJa3P6cJBbGVWvbOqykrrmSRg8Rc%2FJkx%2F4IDlFUyvcCUtyL5mFBv0mUMj3JestHDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab2286815092552799448835e', '满79元减40元', 'http://img.alicdn.com/tfscom/i2/631182111/TB1g5PqnaagSKJjy0FaXXb0dpXa_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i4/631182111/TB2yrpcmLBNTKJjSszbXXaFrFXa_!!631182111.jpg, http://img3.tbcdn.cn/tfscom/i2/631182111/TB2iDLwXwxQ7KJjSZFLXXcdjpXa_!!631182111.jpg, http://img1.tbcdn.cn/tfscom/i4/631182111/TB2djJfrrsTMeJjy1zbXXchlVXa_!!631182111.jpg, http://img3.tbcdn.cn/tfscom/i4/631182111/TB2mGQUmvNNTKJjSspkXXaeWFXa_!!631182111.jpg', '赠送运费险 免费退换货！快递韵达和邮政', '631182111', '2017-10-27', '2017-10-29', '狄秋莎旗舰店', '336', '79.90', '1', '2017-10-29 13:34:56', null, 'https://s.click.taobao.com/653IvYw'), ('9', '541730169994', '新款产自鄂尔多斯羊绒衫女毛衣套头羊毛针织中长款修身包臀打底衫', 'http://detail.tmall.com/item.htm?id=541730169994', 'https://uland.taobao.com/coupon/edetail?e=VCKmtdk1t4oGQASttHIRqV%2FhY3QGftj1Nrr2CgYVVnEYXB958FVfbCHsAhaRY7Wy6WZ1%2BKYhhuzZPcnd%2F7Umfb3%2Fo9ZqIdLKDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab2286815092552799448835e', '满118元减10元', 'http://img.alicdn.com/tfscom/i3/381694434/TB2Hyf9cEMgYeJjSZFGXXXsMXXa_!!381694434.jpg', 'http://img4.tbcdn.cn/tfscom/i4/381694434/TB20albnBcHL1JjSZFBXXaiGXXa_!!381694434.jpg, http://img2.tbcdn.cn/tfscom/i1/381694434/TB24dIimO0TMKJjSZFNXXa_1FXa_!!381694434.jpg, http://img2.tbcdn.cn/tfscom/i3/381694434/TB2kDjNmUl7MKJjSZFDXXaOEpXa_!!381694434.jpg, http://img1.tbcdn.cn/tfscom/i1/381694434/TB2ADpWbCxjpuFjSszeXXaeMVXa_!!381694434.gif', '', '381694434', '2017-10-29', '2017-11-30', '迷你依族名店', '264', '118.00', '1', '2017-10-29 13:34:56', null, 'https://s.click.taobao.com/Wu6IvYw'), ('10', '524848020983', '2017秋冬自留百搭长袖条纹堆堆领高领针织衫修身套头 女式打底衫', 'http://detail.tmall.com/item.htm?id=524848020983', 'https://uland.taobao.com/coupon/edetail?e=xQq%2B%2FZ8aL1gGQASttHIRqQnYtAs6sGqYCbDftwAMWfSOOynoqP64GU3EGbOMU4Jgt59fRTZ3wUJ%2Fg%2FN3FgSkgf7S3R%2FI6FTkDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab2286815092552799448835e', '满10元减5元', 'http://img.alicdn.com/tfscom/i1/TB1LeMPKFXXXXbjaXXXXXXXXXXX_!!0-item_pic.jpg', 'http://img1.tbcdn.cn/tfscom/i3/92781331/TB24yWtipXXXXXCXXXXXXXXXXXX_!!92781331.jpg, http://img4.tbcdn.cn/tfscom/i2/92781331/TB2UQ04ipXXXXbQXpXXXXXXXXXX_!!92781331.jpg, http://img3.tbcdn.cn/tfscom/i1/92781331/TB2lYx0ipXXXXckXpXXXXXXXXXX_!!92781331.jpg, http://img1.tbcdn.cn/tfscom/i2/92781331/TB2xcakipXXXXbAXXXXXXXXXXXX_!!92781331.jpg', '有点堆堆领的设计特别显脸瘦的不会很厚的款式 用来打底穿很赞 细条纹间隔撞色  色彩搭配得有协调  超柔和的~~ 小宽松的版型 上身很显瘦', '92781331', '2017-10-29', '2017-11-03', '馨帮帮sinbounboun', '1968', '29.90', '1', '2017-10-29 13:34:56', null, 'https://s.click.taobao.com/aoCIvYw'), ('11', '557457097722', '打底衫秋冬2017新款韩版针织衫女打底衫长袖蕾丝百搭大码高领毛衣', 'http://detail.tmall.com/item.htm?id=557457097722', 'https://uland.taobao.com/coupon/edetail?e=73himU%2BPQfMGQASttHIRqfGndMKbKYxYYrJf1s4wI9im%2FPqYSC%2BIlsSOfw04P0NFsq7Wvvx3PRzkvzwX2gbg1Z3w%2F%2FVOUtF3DfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTHaUdFGdLbQtQ%3D%3D&traceId=0ab2286815092552799448835e', '满50元减5元', 'http://img.alicdn.com/tfscom/i4/3391744884/TB1IWr2XhDZL1JjSsphXXXUlVXa_!!0-item_pic.jpg', 'http://img3.tbcdn.cn/tfscom/i1/3391744884/TB2woMhXSFRMKJjy0FhXXX.xpXa_!!3391744884.jpg, http://img3.tbcdn.cn/tfscom/i1/3391744884/TB2ItaaaoF7MKJjSZFLXXcMBVXa_!!3391744884.jpg, http://img3.tbcdn.cn/tfscom/i4/3391744884/TB2aPBEXnwKL1JjSZFgXXb6aVXa_!!3391744884.jpg, http://img2.tbcdn.cn/tfscom/i4/3391744884/TB2kVicalRRMKJjSZPhXXcZoVXa_!!3391744884.jpg', '', '3391744884', '2017-10-28', '2017-11-05', '梦黛丝蒂旗舰店', '508', '68.00', '1', '2017-10-29 13:34:56', null, 'https://s.click.taobao.com/7V0IvYw'), ('12', '545311714531', '半高领中袖针织衫女秋季外穿五分袖毛衣加大码修身显瘦半袖打底衫', 'http://detail.tmall.com/item.htm?id=545311714531', 'https://uland.taobao.com/coupon/edetail?e=xbJnrvyD3mAGQASttHIRqdv%2FoV%2FdTKBCrUztRBVuQSwh4%2FBFCEkLWFI0mNaz7XoXnLQIf2oXToOlAmXyLkq%2Fa4lCbtAGqJm9DfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTHnbYfZPG6qkvSs4zOlZ4se&traceId=0ab2cd4515092553036991077e', '满49元减2元', 'http://img.alicdn.com/tfscom/i3/2653105233/TB2G._7er8kpuFjy0FcXXaUhpXa_!!2653105233.jpg', 'http://img2.tbcdn.cn/tfscom/i1/2653105233/TB2lEb3erplpuFjSspiXXcdfFXa_!!2653105233.jpg, http://img3.tbcdn.cn/tfscom/i3/2653105233/TB2SMLOeCBjpuFjSsplXXa5MVXa_!!2653105233.jpg, http://img2.tbcdn.cn/tfscom/i4/2653105233/TB2nnPYewRkpuFjy1zeXXc.6FXa_!!2653105233.jpg, http://img1.tbcdn.cn/tfscom/i2/2653105233/TB2ChzLerBkpuFjy1zkXXbSpFXa_!!2653105233.jpg', '', '2653105233', '2017-10-27', '2017-11-10', '钰嘉时尚大码女装', '46', '49.00', '1', '2017-10-29 13:35:20', null, 'https://s.click.taobao.com/6z2IvYw'), ('13', '556234875407', '喇叭袖针织衫长袖女2017新款韩版时尚套头条纹修身显瘦百搭上衣潮', 'http://detail.tmall.com/item.htm?id=556234875407', 'https://uland.taobao.com/coupon/edetail?e=Ye0vB90ZlTcGQASttHIRqQDUU1kVqudEgLMCoRUMnI%2Bm%2FPqYSC%2BIln0DZQOPht534Xrq52g4RkB2dtMxwrhf7YQOIMd6oUQgDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTHaUdFGdLbQtQ%3D%3D&traceId=0ab2cd4515092553036991077e', '满20元减5元', 'http://img.alicdn.com/tfscom/i4/2866381613/TB1NySDljoIL1JjSZFyXXbFBpXa_!!0-item_pic.jpg', 'http://img3.tbcdn.cn/tfscom/i1/2866381613/TB2crvTcNAlyKJjSZFyXXbm_XXa_!!2866381613.jpg, http://img3.tbcdn.cn/tfscom/i4/2866381613/TB26GTVbwwjyKJjy1zdXXbgZpXa_!!2866381613.jpg, http://img2.tbcdn.cn/tfscom/i2/2866381613/TB27jvIcNolyKJjSZPfXXawNpXa_!!2866381613.jpg, http://img4.tbcdn.cn/tfscom/i3/2866381613/TB2TN6WbuZkyKJjSszgXXcpMpXa_!!2866381613.jpg', '颜色不会过于明亮夸张，却给人一种赏心悦目的韵味，让人移不开眼球！穿在身上优雅迷人，简直是打造窈窕淑女的秘密武器，不知能帮你赚取多少回头率！秋冬时节，让这款针织衫助你活力全开~~', '2866381613', '2017-10-27', '2017-11-10', 'Fairies wardrobe', '336', '29.90', '1', '2017-10-29 13:35:20', null, 'https://s.click.taobao.com/mA0IvYw'), ('14', '536922105910', '2017春秋季新款女装针织开衫中长款斗篷披肩毛衣女秋冬外套上衣潮', 'http://detail.tmall.com/item.htm?id=536922105910', 'https://uland.taobao.com/coupon/edetail?e=tda7k9uq3RgGQASttHIRqUGx1ESnJimYZDzO01TZmFeAnVXUwZx8IteWpEr164%2BdGXJ65ACnZOh4jLFA8WWmQR66%2Bgp9CjaQDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab2cd4515092553036991077e', '满80元减20元', 'http://img.alicdn.com/tfscom/i4/TB1jlkdNpXXXXXJXVXXXXXXXXXX_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i4/2087204593/TB220cOcSOI.eBjy1zkXXadxFXa_!!2087204593.jpg, http://img1.tbcdn.cn/tfscom/i3/2087204593/TB2haPkdxeK.eBjSZFlXXaywXXa_!!2087204593.jpg, http://img4.tbcdn.cn/tfscom/i3/2087204593/TB2x5htbipnpuFjSZFkXXc4ZpXa_!!2087204593.jpg, http://img3.tbcdn.cn/tfscom/i1/2087204593/TB2QtpwXsUX61Bjy0FeXXbvDFXa_!!2087204593.png', '送运费险，不起球 不褪色 不缩水', '2087204593', '2017-10-27', '2017-11-01', '珂典旗舰店', '9497', '88.00', '1', '2017-10-29 13:35:20', null, 'https://s.click.taobao.com/hB1IvYw'), ('15', '549816312959', '2017夏装新款欧美修身气质桑蚕丝a字裙真丝绣花连衣裙女夏中长款', 'http://detail.tmall.com/item.htm?id=549816312959', 'https://uland.taobao.com/coupon/edetail?e=2K3QdP%2BkKrgGQASttHIRqac8ZhVEhBVl3AZzzcxNKcLbLaGB9uZG%2BtYbA6yNYBSxfCJntHozBB5YuPm6ZX8DGinuf4p0U19bDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab290a915094551163576561e', '满299元减20元', 'http://img.alicdn.com/tfscom/i3/764886591/TB1V5L5c8USMeJjSszcXXbnwVXa_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i1/764886591/TB2xFyBqY4npuFjSZFmXXXl4FXa_!!764886591.jpg, http://img3.tbcdn.cn/tfscom/i3/764886591/TB2ERR6obtlpuFjSspoXXbcDpXa_!!764886591.jpg, http://img4.tbcdn.cn/tfscom/i4/764886591/TB2p6MBnR8lpuFjy0FnXXcZyXXa_!!764886591.jpg, http://img1.tbcdn.cn/tfscom/i2/764886591/TB25mq8qylnpuFjSZFgXXbi7FXa_!!764886591.jpg', '', '764886591', '2017-10-12', '2017-11-30', 'jmfive旗舰店', '2', '359.00', '1', '2017-10-31 21:05:22', '￥LJwW0TRTqyQ￥', 'https://s.click.taobao.com/bnmKnYw'), ('16', '559302493825', '韩都衣舍2017冬季新款韩国加厚棉服女中长款宽松百搭韩版外套bf潮', 'http://detail.tmall.com/item.htm?id=559302493825', 'https://uland.taobao.com/coupon/edetail?e=K2%2BN6fN0PekGQASttHIRqQAdqaWL7B3eCITqy9lLGQSAnVXUwZx8Ir3vnggKoICbQ7pKdYurhTcnLe%2B%2BRVq7gJf%2B%2FGr1WivlDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab290a915094551163576561e', '满399元减50元', 'http://img.alicdn.com/tfscom/i1/263817957/TB1i3gaXPihSKJjy0FeXXbJtpXa_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i3/263817957/TB2xbKggC3PL1JjSZFxXXcBBVXa_!!263817957.jpg, http://img3.tbcdn.cn/tfscom/i4/263817957/TB2RrgrbGmWQ1JjSZPhXXXCJFXa_!!263817957.jpg, http://img4.tbcdn.cn/tfscom/i3/263817957/TB2tYpIdgn.PuJjSZFkXXc_lpXa_!!263817957.jpg, http://img4.tbcdn.cn/tfscom/i1/263817957/TB2C6hrXD0ATuJjSZFEXXap2FXa_!!263817957.jpg', '提前狂欢 第2件半价 10.31最后一天', '2274110359', '2017-10-19', '2017-10-31', '韩都衣舍柔朵专卖店', '3', '446.00', '1', '2017-10-31 21:05:22', '￥IHNh0TRTH64￥', 'https://s.click.taobao.com/jqpKnYw'), ('17', '557532890220', 'Hazzys哈吉斯2017新款秋季裤子女休闲裤女长裤女裤女装九分裤女潮', 'http://detail.tmall.com/item.htm?id=557532890220', 'https://uland.taobao.com/coupon/edetail?e=CzYv5E%2BgsT4GQASttHIRqSt%2Fq2YBS5g0SY6tFvryTQXl43M3mIB1t67HAPv175gia%2FJF367ttdA62EUJWBpQ7ES%2BtrmlVJhMDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTHaUdFGdLbQtQ%3D%3D&traceId=0ab290a915094551163576561e', '满1000元减200元', 'http://img.alicdn.com/tfscom/i2/2378266399/TB10VX.mfxNTKJjy0FjXXX6yVXa_!!0-item_pic.jpg', 'http://img3.tbcdn.cn/tfscom/i2/2378266399/TB2Hjd5X3vGK1Jjy0FfXXbykpXa_!!2378266399.jpg, http://img4.tbcdn.cn/tfscom/i2/2378266399/TB2iOEvXnAKL1JjSZFCXXXFspXa_!!2378266399.jpg, http://img4.tbcdn.cn/tfscom/i3/2378266399/TB2soh8X.6FK1Jjy0FpXXbFqVXa_!!2378266399.jpg, http://img1.tbcdn.cn/tfscom/i2/2378266399/TB2Dzh5X.6FK1Jjy1XdXXblkXXa_!!2378266399.jpg', '', '2378266399', '2017-09-19', '2017-10-31', 'hazzys迪睿专卖店', '2', '1431.00', '1', '2017-10-31 21:05:22', '￥1QSC0TRTHvC￥', 'https://s.click.taobao.com/StfKnYw'), ('18', '558177440602', '七格格针织衫套头秋冬新款2017韩版宽松百搭冰丝薄款长袖打底上衣', 'http://detail.tmall.com/item.htm?id=558177440602', 'https://uland.taobao.com/coupon/edetail?e=ELeXfRgOAnkGQASttHIRqWICYRDOOqEGrAtwryfJJvGAnVXUwZx8Iq3CGKUgDC9cSYHvV3%2BYC0fd1VrhvOkcI7ai%2BnrkMiIcDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab290a915094551163576561e', '满50元减5元', 'http://img.alicdn.com/tfscom/i3/848641171/TB1OOgbfXcJL1JjSZFOXXcWlXXa_!!0-item_pic.jpg', 'http://img3.tbcdn.cn/tfscom/i2/394695430/TB2EGwddS7PL1JjSZFHXXcciXXa_!!394695430.jpg, http://img3.tbcdn.cn/tfscom/i2/394695430/TB2Qkv6dFcJL1JjSZFOXXcWlXXa_!!394695430.jpg, http://img3.tbcdn.cn/tfscom/i1/394695430/TB2mA29dUsIL1JjSZPiXXXKmpXa_!!394695430.jpg, http://img2.tbcdn.cn/tfscom/i4/394695430/TB25XZUb8USMeJjy1zjXXc0dXXa_!!394695430.jpg', '', '848641171', '2017-10-09', '2017-10-31', '七格格吉祥TOP潮牌店', '1', '59.90', '1', '2017-10-31 21:05:22', '￥1PZJ0TRTK2I￥', 'https://s.click.taobao.com/UiiKnYw'), ('19', '559123973942', '七格格加绒打底裤女士外穿长2017秋冬韩版灰色小脚高腰铅笔裤', 'http://detail.tmall.com/item.htm?id=559123973942', 'https://uland.taobao.com/coupon/edetail?e=Vi5uzLN53JEGQASttHIRqcI6X4%2F2uDvyH%2FYx6uFv2DGAnVXUwZx8Iq3CGKUgDC9cSYHvV3%2BYC0fd1VrhvOkcI7ai%2BnrkMiIcDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab290a915094551163576561e', '满50元减5元', 'http://img.alicdn.com/tfscom/i3/848641171/TB19CEUkBUSMeJjy1zjXXc0dXXa_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i4/394695430/TB2Po26e3oQMeJjy0FpXXcTxpXa_!!394695430.jpg, http://img2.tbcdn.cn/tfscom/i4/394695430/TB26srSafBNTKJjSszbXXaFrFXa_!!394695430.jpg, http://img3.tbcdn.cn/tfscom/i2/394695430/TB2SIoxh_wKL1JjSZFgXXb6aVXa_!!394695430.jpg, http://img1.tbcdn.cn/tfscom/i4/394695430/TB2tObQafNNTKJjSspkXXaeWFXa_!!394695430.jpg', '', '848641171', '2017-10-09', '2017-10-31', '七格格吉祥TOP潮牌店', '0', '109.90', '1', '2017-10-31 21:05:22', '￥7woA0TRTBBa￥', 'https://s.click.taobao.com/LbpKnYw'), ('20', '559412088377', '宽松韩版毛衣女中长款套头针织衫荷叶边2017新款秋冬季时尚毛衣裙', 'http://detail.tmall.com/item.htm?id=559412088377', 'https://uland.taobao.com/coupon/edetail?e=prD9CbCBqooGQASttHIRqZmO3lliozypiR63pqqVVd2JBiHzvBsckRFhjKdXTG7B0hoKmQKf0Clk4kt0CFj0sPjcYh0gXVkUDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab290a915094551163576561e', '满11元减10元', 'http://img.alicdn.com/tfscom/i1/3077571253/TB1u9ykezihSKJjy0FeXXbJtpXa_!!0-item_pic.jpg', 'http://img1.tbcdn.cn/tfscom/i2/3077571253/TB2L52_iwoQMeJjy0FnXXb8gFXa_!!3077571253.jpg, http://img4.tbcdn.cn/tfscom/i2/3077571253/TB22USGezuhSKJjSspaXXXFgFXa_!!3077571253.jpg, http://img3.tbcdn.cn/tfscom/i4/3077571253/TB2Dc_UirsTMeJjy1zbXXchlVXa_!!3077571253.jpg, http://img1.tbcdn.cn/tfscom/i1/3077571253/TB2YTfCiBUSMeJjy1zkXXaWmpXa_!!3077571253.png', '中长款贴身显瘦毛衣 时尚荷叶边', '3077571253', '2017-10-18', '2017-11-30', '克罗比亚旗舰店', '0', '158.00', '1', '2017-10-31 21:05:22', '￥Si0a0TRTC7B￥', 'https://s.click.taobao.com/yzkKnYw'), ('21', '558299829790', '蝴蝶结领雪纺衬衫女长袖2017秋冬季新款韩范时尚百搭加绒保暖上衣', 'http://detail.tmall.com/item.htm?id=558299829790', 'https://uland.taobao.com/coupon/edetail?e=xQ00hGFKhgIGQASttHIRqZ7vjXWBLkF%2B0hbQSP6c3olYomNqLX%2FiF%2Bwo7%2FcvSOjJy2T3cWx9IAEoQz5uRLm3%2Fs1E128csvwpDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTHaUdFGdLbQtQ%3D%3D&traceId=0ab290a915094551163576561e', '满99元减10元', 'http://img.alicdn.com/tfscom/i4/2840082088/TB2HnCUXZnI8KJjSspeXXcwIpXa_!!2840082088.jpg', 'http://img2.tbcdn.cn/tfscom/i2/2840082088/TB2zsZueEsIL1JjSZPiXXXKmpXa_!!2840082088.jpg, http://img3.tbcdn.cn/tfscom/i3/2840082088/TB26C1OeOAKL1JjSZFoXXagCFXa_!!2840082088.jpg, http://img1.tbcdn.cn/tfscom/i1/2840082088/TB2Bx2sajuhSKJjSspjXXci8VXa_!!2840082088.jpg, http://img1.tbcdn.cn/tfscom/i1/2840082088/TB2SaaKfE3IL1JjSZFMXXajrFXa_!!2840082088.jpg', '', '2840082088', '2017-09-04', '2017-10-31', 'BAYMAY品牌直销店', '363', '128.00', '1', '2017-10-31 21:05:22', '￥E4gG0TRTujs￥', 'https://s.click.taobao.com/6KoKnYw'), ('22', '551001670332', '2017夏装新款修身气质飘逸仙女大摆裙真丝碎花露肩连衣裙子夏长裙', 'http://detail.tmall.com/item.htm?id=551001670332', 'https://uland.taobao.com/coupon/edetail?e=5l9V2AHUrKsGQASttHIRqRABJzvsCPpEeDR5b07h2bnbLaGB9uZG%2BtYbA6yNYBSxfCJntHozBB5YuPm6ZX8DGinuf4p0U19bDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTHaUdFGdLbQtQ%3D%3D&traceId=0ab290a915094551163576561e', '满299元减20元', 'http://img.alicdn.com/tfscom/i2/764886591/TB1gwSmeO0TMKJjSZFNXXa_1FXa_!!0-item_pic.jpg', 'http://img4.tbcdn.cn/tfscom/i3/764886591/TB2OSPXt0FopuFjSZFHXXbSlXXa_!!764886591.jpg, http://img4.tbcdn.cn/tfscom/i3/764886591/TB2isfft5pnpuFjSZFIXXXh2VXa_!!764886591.jpg, http://img2.tbcdn.cn/tfscom/i4/764886591/TB2RTfet5RnpuFjSZFCXXX2DXXa_!!764886591.jpg, http://img1.tbcdn.cn/tfscom/i2/764886591/TB2K2vgt00opuFjSZFxXXaDNVXa_!!764886591.jpg', '短袖真丝碎花连衣裙夏', '764886591', '2017-10-12', '2017-11-30', 'jmfive旗舰店', '1', '389.00', '1', '2017-10-31 21:05:22', '￥25FH0TRTpLK￥', 'https://s.click.taobao.com/uXmKnYw'), ('23', '559600215415', '黑色加绒喇叭裤女冬季新款高腰保暖加厚牛仔裤弹力韩版毛边微喇裤', 'http://detail.tmall.com/item.htm?id=559600215415', 'https://uland.taobao.com/coupon/edetail?e=nOCvQ4lSd8EGQASttHIRqVYZTBU82W6HkYnClgIXt2ym%2FPqYSC%2BIluvRbRxrl8yYdF5ln%2FGvToUJoLh9%2B%2F1ZfX19QPTg95UZDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab290a915094551163576561e', '满129元减10元', 'http://img.alicdn.com/tfscom/i1/2916190944/TB1xWSUjbwTMeJjSszfXXXbtFXa_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i1/TB1ACH3dhuaVKJjSZFjYXIjmpXa_M2.SS2, http://img2.tbcdn.cn/tfscom/i1/TB1XohXc2NZWeJjSZFpYXFjBFXa_M2.SS2, http://img2.tbcdn.cn/tfscom/i8/TB1swXtbzlxYKJjSZFuYXGYlVXa_M2.SS2, http://img2.tbcdn.cn/tfscom/i6/TB112d5ghOMSKJjSZFlYXFqQFXa_M2.SS2', '加绒加厚喇叭牛仔裤 裤子厚 舒服一冬天', '2916190944', '2017-10-30', '2017-11-10', '绚然旗舰店', '311', '129.00', '1', '2017-10-31 21:05:22', '￥VQXH0TRTBBM￥', 'https://s.click.taobao.com/JpoKnYw'), ('24', '559979498331', '半高领针织打底衫女长袖宽松时尚螺纹毛衣外穿秋冬韩版蝙蝠袖上衣', 'http://detail.tmall.com/item.htm?id=559979498331', 'https://uland.taobao.com/coupon/edetail?e=eDhHRalyXLcGQASttHIRqUgd4rIzD4Ua8NoYSRsocUmJBiHzvBsckRFhjKdXTG7B0hoKmQKf0Clk4kt0CFj0sPjcYh0gXVkUDfqEFBOhTcz4jRCV23wObQ%2FrN6BDnc0ca%2FjRkg%2Bay7muLfPfsgnrS%2FvQFWeqWAJiKdLPuG4sKTEy2cj%2FjrDhaA%3D%3D&traceId=0ab290a915094551163576561e', '满11元减10元', 'http://img.alicdn.com/tfscom/i4/3077571253/TB14qXUl3MPMeJjy1XcXXXpppXa_!!0-item_pic.jpg', 'http://img4.tbcdn.cn/tfscom/i2/3077571253/TB2KubThKsAV1JjSZFsXXadZXXa_!!3077571253.jpg, http://img1.tbcdn.cn/tfscom/i2/3077571253/TB2_xyPm0qUQKJjSZFIXXcOkFXa_!!3077571253.jpg, http://img2.tbcdn.cn/tfscom/i3/3077571253/TB2GMQCi1KAUKJjSZFzXXXdQFXa_!!3077571253.jpg, http://img3.tbcdn.cn/tfscom/i4/3077571253/TB2xe4LihuaVKJjSZFjXXcjmpXa_!!3077571253.png', '简约时尚 螺纹针织衫 蝙蝠袖毛衣', '3077571253', '2017-10-18', '2017-11-30', '克罗比亚旗舰店', '1', '158.00', '1', '2017-10-31 21:05:22', '￥wMzL0TRTBr2￥', 'https://s.click.taobao.com/HugKnYw');
COMMIT;

-- ----------------------------
--  Table structure for `ig_jhs`
-- ----------------------------
DROP TABLE IF EXISTS `ig_jhs`;
CREATE TABLE `ig_jhs` (
  `jhsId` int(11) NOT NULL AUTO_INCREMENT COMMENT '聚划算表编号',
  `itemId` bigint(20) DEFAULT NULL COMMENT '商品编号',
  `pcUrl` varchar(500) DEFAULT NULL COMMENT 'pc链接',
  `picUrlForWL` varchar(255) DEFAULT NULL COMMENT '无线主图',
  `smallImages` varchar(500) DEFAULT NULL COMMENT '商品小图',
  `title` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '商品标题',
  `categoryName` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '类别名称',
  `origPrice` double(6,2) DEFAULT NULL COMMENT '原价',
  `actPrice` double(6,2) DEFAULT NULL COMMENT '聚划算价格',
  `onlineStartTime` bigint(20) DEFAULT NULL COMMENT '开团时间',
  `onlineEndTime` bigint(20) DEFAULT NULL COMMENT '开团结束时间',
  `uspDescList` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '卖点',
  `categoryId` int(11) DEFAULT NULL COMMENT '类别编号',
  `addTime` datetime DEFAULT NULL COMMENT '添加时间',
  `tpwd` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '淘口令',
  `shortUrl` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`jhsId`),
  KEY `categoryId` (`categoryId`),
  CONSTRAINT `ig_jhs_ibfk_1` FOREIGN KEY (`categoryId`) REFERENCES `ig_category` (`categoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `ig_jhs`
-- ----------------------------
BEGIN;
INSERT INTO `ig_jhs` VALUES ('22', '538784211255', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D1st5UQa7ujMcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0FCPkupg29xV5b9bmPQ%2BRVQ2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCY1fAJt4yJ5ODatOPQ1GScxi3cxBbJThHjOysup%2F63hf09PhyrZYxFzGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i2/0/TB2FbHPrbsTMeJjy1zcXXXAgXXa_!!0-juitemmedia.jpg', 'http://img4.tbcdn.cn/tfscom/i3/2894992549/TB23W6Ca_1z01JjSZFCXXXY.XXa_!!2894992549.jpg, http://img1.tbcdn.cn/tfscom/i4/2894992549/TB2EjmzbFHzQeBjSZFzXXa__FXa_!!2894992549.jpg, http://img3.tbcdn.cn/tfscom/i3/TB1DxGsOXXXXXbBXpXXXXXXXXXX_!!0-item_pic.jpg, http://img3.tbcdn.cn/tfscom/i2/2894992549/TB2b0IDbJRopuFjSZFtXXcanpXa_!!2894992549.jpg', '90%白鸭绒修身显瘦羽绒服女中长款', '袜子', '768.00', '299.00', '1509156000000', '1509411599000', null, '1', '2017-10-29 12:37:34', null, 'https://s.click.taobao.com/pu5SvYw'), ('23', '556537996865', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D1%2B%2BDBmsBp8ccQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0FCPkupg29xV5b9bmPQ%2BRVQ2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCY6dEO4j8BsAS2sdbAq%2BCzpi3cxBbJThHvAbzVwnPBPijq32XYY%2BcHnGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i2/0/TB2J69lfjihSKJjy0FeXXbJtpXa_!!0-juitemmedia.jpg', null, '90-200斤穿加厚羽绒服韩版中长款女', '袜子', '699.00', '496.00', '1509156000000', '1509411599000', null, '1', '2017-10-29 12:37:34', null, null), ('24', '557463104902', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D6C1u0TaoJNIcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0FCPkupg29xV5b9bmPQ%2BRVQ2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCRjxB6o1gE%2BvY%2BZpyBsVhcFi3cxBbJThHjNebaYq8%2Fgbedve5Dwz13zGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i3/0/TB2dZkMcoRIWKJjSZFgXXboxXXa_!!0-juitemmedia.jpg', 'http://img4.tbcdn.cn/tfscom/i3/192621929/TB2KD15cnAKL1JjSZFCXXXFspXa_!!192621929.jpg, http://img1.tbcdn.cn/tfscom/i1/192621929/TB2oqnBXJ.LL1JjSZFEXXcVmXXa_!!192621929.jpg, http://img1.tbcdn.cn/tfscom/i1/192621929/TB2xXzta.gQMeJjy0FgXXc5dXXa_!!192621929.jpg, http://img4.tbcdn.cn/tfscom/i2/192621929/TB2zZBxXwMPMeJjy1XcXXXpppXa_!!192621929.png', '领券价138！雅鹿短款连帽羽绒服女', '袜子', '599.00', '218.00', '1509242400000', '1509411599000', null, '1', '2017-10-29 12:37:34', null, 'https://s.click.taobao.com/6S8SvYw'), ('25', '535918409425', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D6bzxkYSt1hgcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0FCPkupg29xV5b9bmPQ%2BRVQ2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCX4o00CMueWQNOhW1XoexEZi3cxBbJThHvJPXitjLbZGR6YKJKtJb2bGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i3/0/TB21vgxbiP85uJjSZFKXXcw7FXa_!!0-juitemmedia.jpg', 'http://img4.tbcdn.cn/tfscom/i2/2455486466/TB2gQrzqYsTMeJjy1zeXXcOCVXa_!!2455486466.jpg, http://img2.tbcdn.cn/tfscom/i1/2455486466/TB2Te6JbiP85uJjSZFIXXXISXXa_!!2455486466.jpg, http://img4.tbcdn.cn/tfscom/i1/2455486466/TB2bpTTben85uJjSZFvXXXIgXXa_!!2455486466.jpg, http://img2.tbcdn.cn/tfscom/i2/2455486466/TB2qGt2tXXXXXX.XpXXXXXXXXXX_!!2455486466.jpg', '[领券189]高梵轻薄羽绒服女短款', '袜子', '639.00', '229.00', '1509206400000', '1509465599000', null, '1', '2017-10-29 12:37:34', null, 'https://s.click.taobao.com/FO5SvYw'), ('26', '558499506742', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DYveJC5XH%2BuIcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oKChmzahCkg2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCRo7JVC5viyEn39xlhOWHqli3cxBbJThHsb85LKEoro79JBfuYfOFnbGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i3/3077249091/TB1E9ukcjihSKJjy0FlXXadEXXa_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i1/3077249091/TB2lpFQfamWQ1JjSZPhXXXCJFXa_!!3077249091.jpg, http://img1.tbcdn.cn/tfscom/i1/3077249091/TB248kZXgCYW1JjSZFCXXcxLVXa_!!3077249091.jpg, http://img1.tbcdn.cn/tfscom/i1/3077249091/TB27_iocaigSKJjSsppXXabnpXa_!!3077249091.jpg, http://img1.tbcdn.cn/tfscom/i2/3077249091/TB2XDvxbvBNTKJjSszbXXaFrFXa_!!3077249091.jpg', '[前1500名239元]波司登羽绒服', '袜子', '538.00', '299.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:41:28', null, 'https://s.click.taobao.com/qeURvYw'), ('27', '536929887872', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D0ALGYD309d4cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oKChmzahCkg2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCUCIZVQ0J5NfmagrbsqWnWli3cxBbJThHrpMY9CuMhOiThWmVDFJbXnGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i3/444263296/TB2vsxEXHsTMeJjSszhXXcGCFXa_!!0-juitemmedia.jpg', 'http://img2.tbcdn.cn/tfscom/i1/TB1.kZ6MVXXXXXOaXXXXXXXXXXX_!!0-item_pic.jpg, http://img4.tbcdn.cn/tfscom/i1/444263296/TB2ZLjueEEIL1JjSZFFXXc5kVXa_!!444263296.jpg, http://img3.tbcdn.cn/tfscom/i1/444263296/TB2Bz.2co4WMKJjSspmXXcznpXa_!!444263296.jpg, http://img1.tbcdn.cn/tfscom/i2/444263296/TB2IOjveC3PL1JjSZFtXXclRVXa_!!444263296.jpg', '波司登男装羽绒服轻薄款休闲外套男', '袜子', '1299.00', '258.00', '1509156000000', '1509411599000', null, '2', '2017-10-29 12:41:28', null, 'https://s.click.taobao.com/btSRvYw'), ('28', '559658202679', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DkINHoYpQk1wcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oKChmzahCkg2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCUWHRr0ZD5ueJ9ZVCrTEYpxi3cxBbJThHmSilFcfdsF3nJhdmXc0PvnGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i3/0/TB20wMjXgnD8KJjy1XdXXaZsVXa_!!0-juitemmedia.jpg', 'http://img4.tbcdn.cn/tfscom/i1/673765387/TB1DTSCkF9gSKJjSspbXXbeNXXa_!!0-item_pic.jpg, http://img1.tbcdn.cn/tfscom/i2/673765387/TB2MqHgmvBNTKJjSszbXXaFrFXa_!!673765387.jpg, http://img3.tbcdn.cn/tfscom/i1/673765387/TB2qs2qhDJ_SKJjSZPiXXb3LpXa_!!673765387.jpg, http://img1.tbcdn.cn/tfscom/i4/673765387/TB2A6dbn.UIL1JjSZFrXXb3xFXa_!!673765387.jpg', '[收藏送10元]七匹狼轻薄羽绒服男', '袜子', '999.00', '559.00', '1509156000000', '1509411599000', null, '2', '2017-10-29 12:41:28', null, 'https://s.click.taobao.com/pcSRvYw'), ('29', '538873482202', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DZApTTKs7L%2FwcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oKChmzahCkg2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCSR4pAYfDDwI2i61keuqinpi3cxBbJThHuyU8Ze7ASemNoZ91U6JXcPGJe8N%2FwNpGw%3D%3D', '//gju1.alicdn.com/tps/i4/0/TB2WzT.mPuhSKJjSspjXXci8VXa_!!0-juitemmedia.jpg', 'http://img3.tbcdn.cn/tfscom/i3/1078689692/TB2KVDRqyAKL1JjSZFoXXagCFXa_!!1078689692.jpg, http://img3.tbcdn.cn/tfscom/i2/1078689692/TB2MrelhPihSKJjy0FiXXcuiFXa_!!1078689692.jpg, http://img1.tbcdn.cn/tfscom/i1/1078689692/TB2EiODaHBmpuFjSZFuXXaG_XXa_!!1078689692.jpg, http://img2.tbcdn.cn/tfscom/i3/1078689692/TB2XX_HbUWO.eBjSZPcXXbopVXa_!!1078689692.jpg', '[满300减100]森马羽绒服男', '袜子', '439.00', '319.90', '1509156000000', '1509411599000', null, '2', '2017-10-29 12:41:28', null, 'https://s.click.taobao.com/8SWRvYw'), ('30', '535814003744', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DQgln9lFAcx4cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oKChmzahCkg2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCUrlt%2FpFsAlEKMKM6L%2BS%2FP1i3cxBbJThHmBJCtmPgzehH2GuzVWXbybGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i3/0/TB2Yquol50TMKJjSZFNXXa_1FXa_!!0-juitemmedia.jpg', 'http://img3.tbcdn.cn/tfscom/i4/192621929/TB2utepc77myKJjSZFgXXcT9XXa_!!192621929.jpg, http://img3.tbcdn.cn/tfscom/i4/192621929/TB2TMWoc7onyKJjSZFtXXXNaVXa_!!192621929.jpg, http://img4.tbcdn.cn/tfscom/i1/192621929/TB2i31rc63nyKJjSZFHXXaTCpXa_!!192621929.jpg, http://img4.tbcdn.cn/tfscom/i2/192621929/TB2vSu8ck.OyuJjSszhXXbZbVXa_!!192621929.jpg', '领券价138！雅鹿短款羽绒服男', '袜子', '699.00', '198.00', '1509242400000', '1509411599000', null, '2', '2017-10-29 12:41:28', null, 'https://s.click.taobao.com/TmORvYw'), ('31', '559765701912', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DtEYAC3ozuo0cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oKChmzahCkg2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCUCO0B%2BFWROu9CEMvXLOnixi3cxBbJThHnnoZLJgWkrCAAsH7gu%2BZtrGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i1/0/TB2aaOyXnnI8KJjSszgXXc8ApXa_!!0-juitemmedia.jpg', 'http://img1.tbcdn.cn/tfscom/i1/751506338/TB2xxXrhaagSKJjy0FcXXcZeVXa_!!751506338.jpg, http://img1.tbcdn.cn/tfscom/i1/751506338/TB2OVbykRUSMeJjy1zkXXaWmpXa_!!751506338.jpg, http://img2.tbcdn.cn/tfscom/i4/751506338/TB1R2GCdICNZ1JjSZFHXXb.kVXa_!!0-item_pic.jpg, http://img1.tbcdn.cn/tfscom/i3/751506338/TB2s_EfrbsTMeJjSszgXXacpFXa_!!751506338.png', '马克华菲羽绒服男轻薄短款2017冬季', '袜子', '1095.00', '598.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:41:28', null, 'https://s.click.taobao.com/5uURvYw'), ('32', '542146067916', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DjdbbbKl01O4cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oZ9OtHmqW%2F42wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCaitZ7%2FVMnja6NNyjySoe1Fi3cxBbJThHkV3hMHq0dC7wJeXiw%2BSlrLGJe8N%2FwNpGw%3D%3D', '//gju1.alicdn.com/tps/i2/0/TB29bZrgbsTMeJjy1zeXXcOCVXa_!!0-juitemmedia.jpg', 'http://img2.tbcdn.cn/tfscom/i4/369351818/TB21XXsrgoQMeJjy0FnXXb8gFXa_!!369351818.jpg, http://img1.tbcdn.cn/tfscom/i2/369351818/TB2EvaGrOAKL1JjSZFoXXagCFXa_!!369351818.jpg, http://img1.tbcdn.cn/tfscom/i4/369351818/TB2ri.xa969F1JjSZPiXXXfCXXa_!!369351818.jpg, http://img1.tbcdn.cn/tfscom/i4/369351818/TB2Fl3Da9_9F1JjSZFhXXbadVXa_!!369351818.jpg', '[前100名减100]马克华菲羽绒服男', '袜子', '1095.00', '488.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:05', null, 'https://s.click.taobao.com/L3VRvYw'), ('33', '557639622519', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D2MJsoitxgx8cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oZ9OtHmqW%2F42wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCTVyrC%2BArcLj8XVRNu%2BKdtZi3cxBbJThHt4kAAdWwMUxVUaBxQJHgVnGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i4/0/TB2OGLumvBNTKJjSszeXXcu2VXa_!!0-juitemmedia.jpg', null, '安踏男羽绒服 2017冬季新款', '成人用品', '699.00', '429.00', '1509156000000', '1509411599000', null, '2', '2017-10-29 12:42:05', null, null), ('34', '559103504461', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DW5dCvvrWQfIcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oZ9OtHmqW%2F42wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCQUY8%2F%2BOkNVZVZZnXsL6LDxi3cxBbJThHlrY94XHoXqfBi%2Ba7xF0mbjGJe8N%2FwNpGw%3D%3D', '//gju2.alicdn.com/tps/i1/0/TB22tJeXtbJ8KJjy1zjXXaqapXa_!!0-juitemmedia.jpg', 'http://img3.tbcdn.cn/tfscom/i3/3077249091/TB2ZoRWorsTMeJjy1zbXXchlVXa_!!3077249091.jpg, http://img4.tbcdn.cn/tfscom/i2/3077249091/TB2E2eSowoQMeJjy0FoXXcShVXa_!!3077249091.jpg, http://img4.tbcdn.cn/tfscom/i3/3077249091/TB2CdBDjLNNTKJjSspkXXaeWFXa_!!3077249091.jpg, http://img2.tbcdn.cn/tfscom/i3/3077249091/TB2AqdYorsTMeJjy1zbXXchlVXa_!!3077249091.jpg', '[2件798元]波司登男装羽绒服', '袜子', '1099.00', '498.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:05', null, 'https://s.click.taobao.com/stNRvYw'), ('35', '558921520266', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DBszsswLoZTIcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oZ9OtHmqW%2F42wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCUKHEVK%2B8xSb1z%2FZCRJxeMli3cxBbJThHl7tUHtxkQ0xI7MdDBK7qE%2FGJe8N%2FwNpGw%3D%3D', '//gju1.alicdn.com/tps/i3/0/TB2gfTJm6uhSKJjSspdXXc11XXa_!!0-juitemmedia.jpg', null, '森马羽绒服男2017冬季新款韩版', '袜子', '699.00', '399.90', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:05', null, null), ('36', '559611100059', 'https://s.click.taobao.com/t?e=m%3D2%26s%3Do04rpeNqkPscQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oZ9OtHmqW%2F42wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCf3r8Tcg9kZ2iPLvFzJEt71i3cxBbJThHnORZikOIUzLq%2F0%2FGZQAP6%2FGJe8N%2FwNpGw%3D%3D', '//gju1.alicdn.com/tps/i2/0/TB22j3cg2BNTKJjSszeXXcu2VXa_!!0-juitemmedia.jpg', 'http://img2.tbcdn.cn/tfscom/i2/3077249091/TB2jTkYf6ihSKJjy0FfXXbGzFXa_!!3077249091.jpg, http://img1.tbcdn.cn/tfscom/i2/3077249091/TB2vnZdeURIWKJjSZFgXXboxXXa_!!3077249091.jpg, http://img4.tbcdn.cn/tfscom/i4/3077249091/TB2bCiFc7Gj11JjSZFMXXXnRVXa_!!3077249091.jpg, http://img4.tbcdn.cn/tfscom/i2/3077249091/TB2X2k9hfBNTKJjy0FdXXcPpVXa_!!3077249091.jpg', '[前300名反200]波司登羽绒服', '袜子', '1399.00', '528.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:05', null, 'https://s.click.taobao.com/7dLRvYw'), ('37', '558410399210', 'https://s.click.taobao.com/t?e=m%3D2%26s%3Da2PGqFXjj1ccQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oZ9OtHmqW%2F42wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCfTiHTZeSa0sVZVP624PVWdi3cxBbJThHj0anwAfDQd9M0E4JcRoLWTGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i4/362925212/TB1rmgScwMPMeJjy1XcXXXpppXa_!!0-item_pic.jpg', 'http://img2.tbcdn.cn/tfscom/i3/362925212/TB2CMYIm6ihSKJjy0FeXXbJtpXa-362925212.jpg, http://img2.tbcdn.cn/tfscom/i4/362925212/TB2EhjlXkxF71JjSZFkXXbArpXa-362925212.jpg, http://img4.tbcdn.cn/tfscom/i4/362925212/TB2NhVvrbsTMeJjy1zeXXcOCVXa-362925212.jpg, http://img1.tbcdn.cn/tfscom/i3/362925212/TB2ZK0jmvNNTKJjSspkXXaeWFXa-362925212.jpg', '卡宾男装修身纯色羽绒服2017冬季潮', '袜子', '1299.00', '699.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:05', null, 'https://s.click.taobao.com/N0TRvYw'), ('38', '558395524558', 'https://s.click.taobao.com/t?e=m%3D2%26s%3Dt%2Fc%2Fzee46AMcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8oZ9OtHmqW%2F42wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCRSP%2FhmUAv0yIW50js5Esi9i3cxBbJThHumOWtKx%2BxzMibIG4ebGYozGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i4/0/TB2BvDlfjuhSKJjSspdXXc11XXa_!!0-juitemmedia.jpg', null, '[前50名减200]波司登男装羽绒服', '袜子', '1799.00', '768.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:05', null, null), ('39', '558148866155', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D4zbZ36A7f50cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8gd5GRF2xIpo2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCRSP%2FhmUAv0yWGVxCTUEZsNi3cxBbJThHiGraHuqaYNV0vDKDC86zuDGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i2/0/TB24JshkwMPMeJjy1XcXXXpppXa_!!0-juitemmedia.jpg', null, '[前50名减150]波司登男装羽绒服', '袜子', '1499.00', '538.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:28', null, null), ('40', '537459436325', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DKySiWP20oUkcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8gd5GRF2xIpo2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCYpmiSVTl3Mozyc%2FDE9A3xJi3cxBbJThHp%2BGtAn0Mkm4nr6HMjRWklzGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i3/0/TB2EcZRkEl7MKJjSZFDXXaOEpXa_!!0-juitemmedia.jpg', 'http://img2.tbcdn.cn/tfscom/i4/923679625/TB2XA8zkfNNTKJjSspkXXaeWFXa_!!923679625.jpg, http://img2.tbcdn.cn/tfscom/i4/923679625/TB2mPFoX8_85uJjSZPfXXcp0FXa_!!923679625.jpg, http://img2.tbcdn.cn/tfscom/i2/923679625/TB2ocxCorsTMeJjy1zeXXcOCVXa_!!923679625.jpg, http://img2.tbcdn.cn/tfscom/i1/923679625/TB2SNR7owoQMeJjy0FnXXb8gFXa_!!923679625.jpg', '[满499送皮带]七匹狼羽绒服 男士', '袜子', '899.00', '459.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:28', null, 'https://s.click.taobao.com/JhHRvYw'), ('41', '536840148814', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DNBMgKlgwfo0cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8gd5GRF2xIpo2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCXD1C93h64rRJxCu%2BrGEs0Vi3cxBbJThHoFQjr17ALBvDVR9aioZzQ%2FGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i3/TB1uM9eMVXXXXcDXVXXXXXXXXXX_!!0-item_pic.jpg', 'http://img1.tbcdn.cn/tfscom/i1/752960909/TB2XDmCuXXXXXbAXpXXXXXXXXXX_!!752960909.jpg, http://img4.tbcdn.cn/tfscom/i1/752960909/TB2GrwPdr3XS1JjSZFFXXcvupXa_!!752960909.jpg, http://img3.tbcdn.cn/tfscom/i1/752960909/TB2I2m.uXXXXXa6XXXXXXXXXXXX_!!752960909.jpg, http://img1.tbcdn.cn/tfscom/i2/752960909/TB2svr2czuhSKJjSspdXXc11XXa_!!752960909.jpg', '艾莱依90%白鸭绒男士羽绒服', '袜子', '968.00', '339.00', '1509156000000', '1509325199000', null, '2', '2017-10-29 12:42:28', null, 'https://s.click.taobao.com/U2NRvYw'), ('42', '540474755480', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DZMFDgL%2FwQWQcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8gd5GRF2xIpo2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCSH9HRGEQSr8QcByYagR4CNi3cxBbJThHkM1NQmNiSJtAj9raoyjoubGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i2/727496057/TB2kMoTXDZRMeJjSsppXXXrEpXa_!!0-juitemmedia.jpg', 'http://img1.tbcdn.cn/tfscom/i2/727496057/TB2_akoXnvI8KJjSspjXXcgjXXa_!!727496057.jpg, http://img1.tbcdn.cn/tfscom/i4/727496057/TB2JxGeaNuI.eBjy0FdXXXgbVXa_!!727496057.jpg, http://img1.tbcdn.cn/tfscom/i4/727496057/TB2LZMjXbb85uJjSZFmXXcgsFXa_!!727496057.jpg, http://img4.tbcdn.cn/tfscom/i4/727496057/TB2CTshawsSMeJjSspcXXXjFXXa_!!727496057.jpg', '[领券满300减100]WOOG羽绒服男', '袜子', '695.00', '348.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:28', null, 'https://s.click.taobao.com/P9RRvYw'), ('43', '556599064321', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DXREWqtTV5WQcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8gd5GRF2xIpo2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCZFBVtf2AeeIeBoZ%2FwxW9cpi3cxBbJThHtgNH0JPa1xORz%2FbghYVVlHGJe8N%2FwNpGw%3D%3D', '//gju2.alicdn.com/tps/i3/0/TB2ZHEsbg685uJjSZFCXXXzlXXa_!!0-juitemmedia.jpg', null, '森马羽绒服男2017冬季新款男士', '袜子', '659.00', '539.90', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:28', null, null), ('44', '559601256418', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DE7uklSzXIb4cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8gd5GRF2xIpo2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCUCO0B%2BFWROuS2sdbAq%2BCzpi3cxBbJThHqJ3QIdYlupdEKHYyfyjqjzGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i3/0/TB2K73PmvBNTKJjy0FdXXcPpVXa_!!0-juitemmedia.jpg', 'http://img1.tbcdn.cn/tfscom/i4/751506338/TB1xqMXbkGj11JjSZFMXXXnRVXa_!!0-item_pic.jpg, http://img3.tbcdn.cn/tfscom/i3/751506338/TB2SD.1l3oQMeJjy0FnXXb8gFXa_!!751506338.jpg, http://img4.tbcdn.cn/tfscom/i4/751506338/TB2SMhifvBNTKJjSszeXXcu2VXa_!!751506338.jpg, http://img1.tbcdn.cn/tfscom/i2/751506338/TB2xS64fWagSKJjy0FgXXcRqFXa_!!751506338.jpg', '马克华菲羽绒服男长款连帽白鸭绒', '袜子', '1355.00', '658.00', '1509206400000', '1509465599000', null, '2', '2017-10-29 12:42:28', null, 'https://s.click.taobao.com/GYMRvYw'), ('45', '557552970896', 'https://s.click.taobao.com/t?e=m%3D2%26s%3Dk74KYPQ6h4QcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0EB3aZRW6Vp8gd5GRF2xIpo2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCQTrJ8CpIvWzi3KtEuQR2uli3cxBbJThHtkJuMT%2B2JX6%2BtyGrhfWvDbGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i2/0/TB2998ZgGmWQ1JjSZPhXXXCJFXa_!!0-juitemmedia.jpg', 'http://img2.tbcdn.cn/tfscom/i2/363607599/TB2X0JBcfBNTKJjy1zdXXaScpXa_!!363607599.jpg, http://img3.tbcdn.cn/tfscom/i1/363607599/TB2ToJHgYsTMeJjy1zcXXXAgXXa_!!363607599.jpg, http://img4.tbcdn.cn/tfscom/i2/363607599/TB2dHodcPihSKJjy0FeXXbJtpXa_!!363607599.jpg, http://img1.tbcdn.cn/tfscom/i3/363607599/TB2B_GtXiERMeJjy0FdXXaIbpXa_!!363607599.jpg', '361男装2017秋冬季新款男羽绒服', '成人用品', '529.00', '289.00', '1509156000000', '1509411599000', null, '2', '2017-10-29 12:42:28', null, 'https://s.click.taobao.com/wXLRvYw'), ('46', '537745490728', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DXujwar%2F5ZkwcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCfiXXV1vvhu%2FFoFTzHqzKTxi3cxBbJThHg8pwY52OkwKuSm0Bzv9R%2FrGJe8N%2FwNpGw%3D%3D', '//gju1.alicdn.com/tps/TB2usr9cp6.F1JjSZFpXXcZjXXa_!!698044520.jpg', 'http://img2.tbcdn.cn/tfscom/i3/725677994/TB1.TyGXNPI8KJjSspoXXX6MFXa_!!0-item_pic.jpg, http://img4.tbcdn.cn/tfscom/i3/725677994/TB2HqZbjaagSKJjy0FhXXcrbFXa_!!725677994.jpg, http://img4.tbcdn.cn/tfscom/i4/725677994/TB2iritdK7JL1JjSZFKXXc4KXXa_!!725677994.jpg, http://img1.tbcdn.cn/tfscom/i3/725677994/TB2_p_jb.gQMeJjy0FjXXaExFXa_!!725677994.jpg', '清风抽纸中规格140抽24包', '家装其他', '139.90', '49.90', '1509328800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥RjOc0TR4XYQ￥', 'https://s.click.taobao.com/hWtLnYw'), ('47', '558455283127', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DeLDlL0kKvw4cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCR50G4DySBx0G5ZdXLZ%2B18Fi3cxBbJThHgLTOihOdD1L29wWJdOWVnvGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/i1/2939922051/TB2YvaFc5ERMeJjSspiXXbZLFXa_!!0-juitemmedia.jpg', 'http://img1.tbcdn.cn/tfscom/i1/2939922051/TB2eEeEcBUSMeJjSszeXXcKgpXa_!!2939922051.jpg, http://img2.tbcdn.cn/tfscom/i4/2939922051/TB2GwBreDwKL1JjSZFgXXb6aVXa_!!2939922051.jpg, http://img4.tbcdn.cn/tfscom/i2/2939922051/TB2XKL1aMMPMeJjy1XdXXasrXXa_!!2939922051.jpg, http://img2.tbcdn.cn/tfscom/i3/2939922051/TB2WyxwdyAKL1JjSZFoXXagCFXa_!!2939922051.jpg', '第3件0.01元，王小二红肉蜜柚', '医药', '59.10', '29.80', '1509292800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥xlIi0TR4ZK0￥', 'https://s.click.taobao.com/Y3vLnYw'), ('48', '558456523620', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DlmhcZsRV%2FG0cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCW5UkyxLk1zWamatFAgZusJi3cxBbJThHqmkYtUj44JvxGNJvrmCQC7GJe8N%2FwNpGw%3D%3D', '//gju2.alicdn.com/tps/i1/2772080898/TB2pIz.XdfJ8KJjy0FeXXXKEXXa_!!0-juitemmedia.jpg', 'http://img2.tbcdn.cn/tfscom/i2/2772080898/TB2L4SllGagSKJjy0FbXXa.mVXa_!!2772080898.jpg, http://img4.tbcdn.cn/tfscom/i1/2772080898/TB2kWL2jHsTMeJjy1zbXXchlVXa_!!2772080898.jpg, http://img3.tbcdn.cn/tfscom/i3/2772080898/TB24kgdjMoQMeJjy0FnXXb8gFXa_!!2772080898.jpg, http://img4.tbcdn.cn/tfscom/i3/2772080898/TB2lPC8XbPx2eJjSZFBXXbmZVXa_!!2772080898.jpg', '第2件0.1第3件1分 现摘百香果', '医药', '39.80', '29.80', '1509328800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥KhZ40TRVsiU￥', 'https://s.click.taobao.com/g1uLnYw'), ('49', '41141176393', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DoKe7xZKkXF4cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCRG3tA9rr4nTkqmrBJ8gcMVi3cxBbJThHgXzkNavFzS%2FZ2AqASCspf6iZ%2BQMlGz6FQ%3D%3D', '//gju3.alicdn.com/tps/TB2OrCYX4Qa61Bjy0FhXXaalFXa_!!2135196713.jpg', 'http://img3.tbcdn.cn/tfscom/i3/725677994/TB1buG1XtHO8KJjSZFtXXchfXXa_!!0-item_pic.jpg, http://img2.tbcdn.cn/tfscom/i3/725677994/TB2AcccdXXXXXa0XXXXXXXXXXXX_!!725677994.jpg, http://img2.tbcdn.cn/tfscom/i1/725677994/TB2QhD2dXXXXXXVXpXXXXXXXXXX_!!725677994.jpg, http://img1.tbcdn.cn/tfscom/i4/725677994/TB2uXaxvYRkpuFjSspmXXc.9XXa_!!725677994.jpg', '维达经典卷纸3层140g27卷', '家装其他', '71.00', '49.90', '1509328800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥Y0xJ0TRVyHF￥', 'https://s.click.taobao.com/bezLnYw'), ('50', '554875851318', 'https://s.click.taobao.com/t?e=m%3D2%26s%3Dpvr7fxQbaLUcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCfiXXV1vvhu%2FoOEkSLFN%2BMli3cxBbJThHpfR9cCBqCXwpZ0moA9CDfvGJe8N%2FwNpGw%3D%3D', '//gju3.alicdn.com/tps/TB2k8dAfzoIL1JjSZFyXXbFBpXa_!!698044520.jpg', 'http://img2.tbcdn.cn/tfscom/i4/725677994/TB1ziDDXRDH8KJjSspnXXbNAVXa_!!0-item_pic.jpg, http://img3.tbcdn.cn/tfscom/i4/725677994/TB2svhqvYXlpuFjy1zbXXb_qpXa_!!725677994.jpg, http://img3.tbcdn.cn/tfscom/i2/725677994/TB2XtkfAhlmpuFjSZPfXXc9iXXa_!!725677994.jpg, http://img3.tbcdn.cn/tfscom/i4/725677994/TB2xr6sAipnpuFjSZFIXXXh2VXa_!!725677994.jpg', '清风原木高克重卷纸足足200克27卷', '家装其他', '170.00', '59.90', '1509328800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥LXJ20TRVBg7￥', 'https://s.click.taobao.com/xuoLnYw'), ('51', '521949685764', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DuR%2F2gIwOHckcQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCU9zKTpOI99oPmP2s6SsMwhi3cxBbJThHnsazEIchDnriyfWWKfBRv3GJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/i4/0/TB2lLQ3l2JNTKJjSspoXXc6mpXa_!!0-juitemmedia.jpg', 'http://img3.tbcdn.cn/tfscom/i4/2183635442/TB2TTNorrtlpuFjSspoXXbcDpXa_!!2183635442.jpg, http://img1.tbcdn.cn/tfscom/i2/2183635442/TB2UagLfekJL1JjSZFmXXcw0XXa_!!2183635442.jpg, http://img2.tbcdn.cn/tfscom/i3/2183635442/TB2IpTgXTJ_SKJjSZPiXXb3LpXa_!!2183635442.jpg, http://img1.tbcdn.cn/tfscom/i2/2183635442/TB2atIWXZrC11Bjy1zjXXcduVXa_!!2183635442.png', '乐拖冬季厚底情侣居家防水棉拖鞋', '家装其他', '68.00', '18.90', '1509292800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥td2J0TRVutO￥', 'https://s.click.taobao.com/GhpLnYw'), ('52', '548917187511', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DJlem9KGDu30cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCeeyqbXd2uEUYfb%2Bxz0ACT5i3cxBbJThHjuqq5g%2FX49jaZLVTfj2uwHGJe8N%2FwNpGw%3D%3D', '//gju4.alicdn.com/tps/TB2PGlcarsTMeJjy1zeXXcOCVXa_!!1709193846.jpg', 'http://img4.tbcdn.cn/tfscom/i4/725677994/TB1ZVGAXInI8KJjSspeXXcwIpXa_!!2-item_pic.png, http://img2.tbcdn.cn/tfscom/i1/725677994/TB21UN1b6oIL1JjSZFyXXbFBpXa_!!725677994.jpg, http://img1.tbcdn.cn/tfscom/i1/725677994/TB2X0vepgxlpuFjSszbXXcSVpXa_!!725677994.jpg, http://img1.tbcdn.cn/tfscom/i4/725677994/TB2M2bRaHsTMeJjSszgXXacpFXa_!!725677994.jpg', '福临门苏北米苏软香10KG', '医药', '59.80', '55.80', '1509292800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥VXbh0TRVzng￥', 'https://s.click.taobao.com/5BpLnYw'), ('53', '556908501626', 'https://s.click.taobao.com/t?e=m%3D2%26s%3Db7eOnF2aYE0cQipKwQzePCperVdZeJviEViQ0P1Vf2lyINtkUhsv0CFJMSfDkbCR9lrAC0GScxY2wygkwYEuXeV0p6E77Np1X58GPoPxRI9Ex7Eje71Rpab6h%2BauVgdyCEDNGBpwx5iM%2BhtH71aX6kp%2FwIWvRyqkX2fzFUAiwnKdpikUEh8L%2Fca665w3oSyy3rqiv%2BpOFcqJ%2BxJAp7TmCXIPyG%2FWUQkNDjAgvCdXIGFi3cxBbJThHq6u0fcMsNMZGUxkYSn3pCXGJe8N%2FwNpGw%3D%3D', '//gju1.alicdn.com/tps/i4/2907408775/TB12lgGdYsTMeJjSszgXXacpFXa_!!0-item_pic.jpg', 'http://img1.tbcdn.cn/tfscom/i4/2907408775/TB18ewASFXXXXawXVXXXXXXXXXX_!!0-item_pic.jpg, http://img2.tbcdn.cn/tfscom/i4/2907408775/TB2Emr8bxr9F1JjSZPfXXawbFXa_!!2907408775.jpg, http://img4.tbcdn.cn/tfscom/i4/2907408775/TB2wz7ZalUSMeJjSspfXXX0VFXa_!!2907408775.jpg, http://img3.tbcdn.cn/tfscom/i1/2907408775/TB2hJsYalUSMeJjy1zkXXaWmpXa_!!2907408775.jpg', '[2件减3元，3件减5]加绒加厚卫衣', '袜子', '55.00', '29.00', '1509292800000', '1509465599000', null, '1', '2017-10-31 20:59:48', '￥KKbj0TR41ZG￥', 'https://s.click.taobao.com/6pxLnYw');
COMMIT;

-- ----------------------------
--  Table structure for `ig_shopevent`
-- ----------------------------
DROP TABLE IF EXISTS `ig_shopevent`;
CREATE TABLE `ig_shopevent` (
  `eventId` int(11) NOT NULL AUTO_INCREMENT COMMENT '店铺活动编号',
  `eventPic` varchar(200) DEFAULT NULL COMMENT '活动图片',
  `eventTitle` varchar(50) DEFAULT NULL COMMENT '活动标题',
  `eventUrl` varchar(500) DEFAULT NULL COMMENT '活动链接地址',
  `eventOrder` int(11) DEFAULT NULL COMMENT '活动排序',
  `eventPlatform` varchar(20) DEFAULT NULL COMMENT '活动平台',
  `shopName` varchar(200) DEFAULT NULL COMMENT '店铺名称',
  `eventType` varchar(20) DEFAULT NULL COMMENT '活动类型(新品推广,优惠促销,品牌专辑)',
  `eventStartTime` varchar(255) DEFAULT NULL COMMENT '活动开始时间',
  `eventEndTime` varchar(255) DEFAULT NULL COMMENT '活动结束时间',
  `addTime` datetime DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`eventId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `ig_tqg`
-- ----------------------------
DROP TABLE IF EXISTS `ig_tqg`;
CREATE TABLE `ig_tqg` (
  `tqgId` int(11) NOT NULL AUTO_INCREMENT COMMENT '淘抢购编号',
  `numIid` bigint(20) DEFAULT NULL COMMENT '商品ID',
  `title` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '商品标题',
  `picUrl` varchar(255) DEFAULT NULL COMMENT '商品主图',
  `smallImages` varchar(500) DEFAULT NULL COMMENT '商品小图',
  `categoryName` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '类目名称',
  `clickUrl` varchar(500) DEFAULT NULL COMMENT '商品链接',
  `startTime` varchar(20) DEFAULT NULL COMMENT '开团时间',
  `endTime` varchar(20) DEFAULT NULL COMMENT '结束时间',
  `reservePrice` double(6,2) DEFAULT NULL COMMENT '商品原价',
  `zkFinalPrice` double(6,2) DEFAULT NULL COMMENT '淘抢购活动价',
  `soldNum` bigint(20) DEFAULT NULL COMMENT '已抢购数量',
  `categoryId` int(11) DEFAULT NULL COMMENT '类别编号',
  `tpwd` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '淘口令(￥XXXXX￥)',
  `addTime` datetime DEFAULT NULL COMMENT '添加时间',
  `shortUrl` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tqgId`),
  KEY `categoryId` (`categoryId`),
  CONSTRAINT `ig_tqg_ibfk_1` FOREIGN KEY (`categoryId`) REFERENCES `ig_category` (`categoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `ig_tqg`
-- ----------------------------
BEGIN;
INSERT INTO `ig_tqg` VALUES ('86', '559080807277', '[试驾]观致3 GT 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju1.alicdn.com/tps/i3/0/TB2p8n8mMoQMeJjy0FpXXcTxpXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=559080807277', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:51:57', null), ('87', '558962465017', '[试驾]观致3 都市SUV 秒杀', 'http://img4.tbcdn.cn/tfscom///gju1.alicdn.com/tps/i2/0/TB2V1v0mMoQMeJjy1XaXXcSsFXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=558962465017', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:51:57', null), ('88', '558872884344', '[试驾]观致5 SUV 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju3.alicdn.com/tps/i4/0/TB2DjIzmMoQMeJjy0FoXXcShVXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=558872884344', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:51:57', null), ('89', '559082135117', '[试驾]观致3五门版 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju4.alicdn.com/tps/i3/0/TB2Z6d5fZCNZ1JjSZFHXXb.kVXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=559082135117', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:51:57', null), ('90', '559081835031', '[试驾]观致3轿车 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju4.alicdn.com/tps/i2/0/TB2fdadiPihSKJjy0FiXXcuiFXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=559081835031', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:51:57', null), ('91', '559080807277', '[试驾]观致3 GT 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju1.alicdn.com/tps/i3/0/TB2p8n8mMoQMeJjy0FpXXcTxpXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=559080807277', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:53:02', null), ('92', '558962465017', '[试驾]观致3 都市SUV 秒杀', 'http://img4.tbcdn.cn/tfscom///gju1.alicdn.com/tps/i2/0/TB2V1v0mMoQMeJjy1XaXXcSsFXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=558962465017', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:53:02', null), ('93', '558872884344', '[试驾]观致5 SUV 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju3.alicdn.com/tps/i4/0/TB2DjIzmMoQMeJjy0FoXXcShVXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=558872884344', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:53:02', null), ('94', '559082135117', '[试驾]观致3五门版 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju4.alicdn.com/tps/i3/0/TB2Z6d5fZCNZ1JjSZFHXXb.kVXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=559082135117', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:53:02', null), ('95', '559081835031', '[试驾]观致3轿车 秒杀资格', 'http://img4.tbcdn.cn/tfscom///gju4.alicdn.com/tps/i2/0/TB2fdadiPihSKJjy0FiXXcuiFXa_!!0-juitemmedia.jpg', null, '车品旅行', 'http://item.taobao.com/item.htm?id=559081835031', '2017-11-01 00:00:00', '2017-11-01 23:59:59', '1.00', '1.00', '0', '1', null, '2017-10-31 20:53:02', null), ('96', '528592262119', '鹿皮巾擦车巾加厚洗车毛巾麂皮', 'http://img4.tbcdn.cn/tfscom///gju2.alicdn.com/tps/i1/1454106049296699876/TB2ur4oq9hlpuFjSspkXXa1ApXa_!!2-juitemmedia.png', 'http://img3.tbcdn.cn/tfscom/i4/1093464541/TB28z8fhgFkpuFjSspnXXb4qFXa_!!1093464541.jpg, http://img2.tbcdn.cn/tfscom/i3/1093464541/TB2CGiNXZrC11Bjy1zjXXcduVXa_!!1093464541.jpg, http://img3.tbcdn.cn/tfscom/i3/1093464541/TB2Kzf5qpXXXXXeXXXXXXXXXXXX_!!1093464541.jpg, http://img4.tbcdn.cn/tfscom/i3/1093464541/TB2HT1_bpLzQeBjSZJiXXXesFXa_!!1093464541.jpg', '车品旅行', 'https://s.click.taobao.com/t?e=m%3D2%26s%3D8Asq0bZmMkEcQipKwQzePOeEDrYVVa64yK8Cckff7TVRAdhuF14FMZkaIaljoN7SRitN3%2FurF3x68LeVp3U7p%2BTjrNJqRqH4lVHSUQIvIYm6zIr6z0vTPHbOdFtc4uDS06qvb4lce%2B9TX8ze124PMgyZ%2BtYOEFx6NXrZvm3OFHJSxsTL6uYh8tw8geLiPPevpRdIF50i8aKTO%2FuhrJpZlA%3D%3D', '2017-11-01 08:00:00', '2017-11-02 07:59:59', '9.90', '5.40', '0', '1', '￥z4hO0TRXAjx￥', '2017-10-31 20:53:02', 'https://s.click.taobao.com/bUpNnYw'), ('97', '542919316545', '倍量cr2025纽扣电池5粒装', 'http://img4.tbcdn.cn/tfscom///gju1.alicdn.com/tps/i4/1334105000868392416/TB2L6fzdJRopuFjSZFtXXcanpXa_!!0-juitemmedia.jpg', 'http://img3.tbcdn.cn/tfscom/i3/2871683341/TB2cPXiarXlpuFjSszfXXcSGXXa_!!2871683341.jpg, http://img2.tbcdn.cn/tfscom/i2/2072921814/TB2a32kXHBmpuFjSZFAXXaQ0pXa_!!2072921814.jpg, http://img2.tbcdn.cn/tfscom/i1/2072921814/TB2UmFKXR8lpuFjSspaXXXJKpXa_!!2072921814.jpg, http://img3.tbcdn.cn/tfscom/i3/2871683341/TB2jjP1clNkpuFjy0FaXXbRCVXa_!!2871683341.jpg', '数码电器', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DvzduxN66K8gcQipKwQzePOeEDrYVVa64yK8Cckff7TVRAdhuF14FMZkaIaljoN7SRitN3%2FurF3x68LeVp3U7p%2BTjrNJqRqH4lVHSUQIvIYm6zIr6z0vTPHbOdFtc4uDS06qvb4lce%2B9TX8ze124PMlM%2FDyH7wxo20wIkQztDF7xvue%2BMUQeaHIgM1CKfEfRfpRdIF50i8aKTO%2FuhrJpZlA%3D%3D', '2017-10-31 08:00:00', '2017-11-01 07:59:59', '12.00', '5.69', '330', '1', '￥ofSS0TR2UW8￥', '2017-10-31 20:53:02', 'https://s.click.taobao.com/vioNnYw'), ('98', '39767291451', '松下开关简尚二三插五孔插座', 'http://img4.tbcdn.cn/tfscom///gju3.alicdn.com/tps/i4/156540201906253722/TB2Wq2GnpXXXXXGXXXXXXXXXXXX_!!2-juitemmedia.png', 'http://img1.tbcdn.cn/tfscom/i3/2144325654/TB270IGXJbJ8KJjy1zjXXaqapXa_!!2144325654.jpg, http://img4.tbcdn.cn/tfscom/i4/2144325654/TB24LTXaVHzQeBjSZFuXXanUpXa_!!2144325654.jpg, http://img2.tbcdn.cn/tfscom/i3/2144325654/TB2EEC2a1rAQeBjSZPcXXbJ6pXa_!!2144325654.jpg, http://img4.tbcdn.cn/tfscom/i1/2144325654/TB2lyoIXMvD8KJjSsplXXaIEFXa_!!2144325654.jpg', '家纺家居', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DaQikNbhmtO4cQipKwQzePOeEDrYVVa64yK8Cckff7TVRAdhuF14FMZkaIaljoN7SRitN3%2FurF3x68LeVp3U7p%2BTjrNJqRqH4lVHSUQIvIYm6zIr6z0vTPHbOdFtc4uDS06qvb4lce%2B9TX8ze124PMk97CW12FA3ZnP%2BZMqhSE%2BP0cc2LATRS6F16tGJCD2XU6pEmUhkETZtMdIp1rr4P3Q%3D%3D', '2017-10-31 17:00:00', '2017-11-01 16:59:59', '23.46', '7.40', '59', '1', '￥QCHI0TR2VMc￥', '2017-10-31 20:53:02', 'https://s.click.taobao.com/FSnNnYw'), ('99', '559602877367', '5条8层洗碗布加厚不沾油', 'http://img4.tbcdn.cn/tfscom///gju3.alicdn.com/tps/i4/0/TB2_aM3XlDH8KJjy1zeXXXjepXa_!!0-juitemmedia.jpg', 'http://img4.tbcdn.cn/tfscom/i2/2640722640/TB2SIDEXDvI8KJjSspjXXcgjXXa_!!2640722640.jpg, http://img4.tbcdn.cn/tfscom/i3/2640722640/TB2MTfDXBfH8KJjy1XbXXbLdXXa_!!2640722640.jpg, http://img4.tbcdn.cn/tfscom/i2/2640722640/TB2rQDFXwnD8KJjy1XdXXaZsVXa_!!2640722640.jpg, http://img1.tbcdn.cn/tfscom/i3/2640722640/TB2dFDHXvDH8KJjy1XcXXcpdXXa_!!2640722640.jpg', '居家百货', 'https://s.click.taobao.com/t?e=m%3D2%26s%3Dj8tXUHnrODscQipKwQzePOeEDrYVVa64XoO8tOebS%2BdRAdhuF14FMZkaIaljoN7SRitN3%2FurF3x68LeVp3U7p%2BTjrNJqRqH4lVHSUQIvIYm6zIr6z0vTPHbOdFtc4uDS06qvb4lce%2B9TX8ze124PMlB3hdCZObSnlIi5ADQBs1K%2B%2Fy1xzDX21QHBx7%2BKpP86pRdIF50i8aKTO%2FuhrJpZlA%3D%3D', '2017-10-31 17:00:00', '2017-11-01 16:59:59', '18.00', '7.70', '10', '1', '￥0BxC0TR2ebJ￥', '2017-10-31 20:53:02', 'https://s.click.taobao.com/iYtNnYw'), ('100', '553856302931', '源氏老式80后大辣片230g', 'http://img4.tbcdn.cn/tfscom///gju3.alicdn.com/tps/i4/2081314055/TB2LaYRXkT85uJjSZFhXXcPEVXa_!!2-juitemmedia.png', 'http://img2.tbcdn.cn/tfscom/i2/2081314055/TB2pn3ryrBmpuFjSZFuXXaG_XXa_!!2081314055.jpg, http://img4.tbcdn.cn/tfscom/i4/2081314055/TB2UJ.kdTAKh1JjSZFDXXbKlFXa_!!2081314055.jpg, http://img3.tbcdn.cn/tfscom/i1/2081314055/TB2bQMAyr4npuFjSZFmXXXl4FXa_!!2081314055.jpg, http://img3.tbcdn.cn/tfscom/i2/2081314055/TB2DBZyyrBmpuFjSZFAXXaQ0pXa_!!2081314055.png', '食品', 'https://s.click.taobao.com/t?e=m%3D2%26s%3DJmMQXWeiLWYcQipKwQzePOeEDrYVVa64yK8Cckff7TVRAdhuF14FMZkaIaljoN7SRitN3%2FurF3x68LeVp3U7p%2BTjrNJqRqH4lVHSUQIvIYm6zIr6z0vTPHbOdFtc4uDS06qvb4lce%2B9TX8ze124PMvcZ%2FyiMYlgq7k6BX8GR%2Fc0L%2FjVPv7xdIcmzKzeg3Q4UpRdIF50i8aKTO%2FuhrJpZlA%3D%3D', '2017-10-31 19:00:00', '2017-11-01 18:59:59', '32.00', '7.90', '74', '1', '￥W2da0TR2hYy￥', '2017-10-31 20:53:02', 'https://s.click.taobao.com/JgmNnYw');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
